---------------------------------------------------------------------------------------------------
IF (SELECT OBJECT_ID('[ServiceMemberManagement].[GetAllTypesOfDischarge]')) IS NOT NULL
BEGIN
	DROP PROCEDURE [ServiceMemberManagement].[GetAllTypesOfDischarge] 
END
GO
---------------------------------------------------------------------------------------------------

CREATE PROCEDURE [ServiceMemberManagement].[GetAllTypesOfDischarge]
AS 

SET NOCOUNT ON 

SELECT 	OID,
		Description,
		Version,
		DisplayOrder
FROM dbo.TypesOfDischarge
WHERE Active = 1        
ORDER BY DisplayOrder    

GO

---------------------------------------------------------------------------------------------------
-- Assign appropriate permissions
---------------------------------------------------------------------------------------------------
GRANT EXECUTE ON [ServiceMemberManagement].[GetAllTypesOfDischarge] TO [Liberty_Users]
GO

